CREATE TABLE "member" (
    "id" INTEGER PRIMARY KEY,
    "surname" TEXT,
    "name" TEXT,
    "lastName" TEXT,
    "dateOfBirth" TEXT
);

CREATE TABLE "active_member" (
    "id" INTEGER,
    FOREIGN KEY ("id") REFERENCES "member"("id"),
    PRIMARY KEY ("id")
);

CREATE TABLE "attendance" (
    "date" TEXT,
    "member" INTEGER,
    FOREIGN KEY ("member") REFERENCES "member"("id"),
    PRIMARY KEY ("date", "member")
);
